-- source control
--	Joju		06/08/2000	created
-- insert into t_IdentityControl values ('common','t_ItemMaster',1500,'CMV')
-- insert into t_IdentityControl values ('common','t_SalesOrder',1500,'CMV')
use common
go

if exists(select 1 from sysobjects where name="t_IdentityControl")
	drop table t_IdentityControl
go

create table t_IdentityControl
(
	DbName		varchar(40),	-- name of database where table resides.
	TblName		varchar(40),	-- name of table to generate id for
	LastId		int,			-- last used id
	CompanyName	varchar(40)		-- name of CompanyName to generate id for
)
lock datarows
go

grant select on t_IdentityControl to public
go
